create external table jms_dm.dm_enough_goods_detail_dt 
(
center_code_1                    string COMMENT '始发中心' ,
center_code_2                    string COMMENT '中转中心' ,
center_code_3                    string COMMENT '目的中心' ,
center_name_1                    string COMMENT '始发中心name' ,
center_name_2                    string COMMENT '中转中心name' ,
center_name_3                    string COMMENT '目的中心name' ,
bill_cnt 4)  bill_cnt                      string COMMENT '平均票数' ,
package_total_volume4)  package_total_volume           string COMMENT '总体积' ,
avg_package_total_volume4) avg_package_total_volume        string COMMENT '平均体积' ,
planned_arrival_time             timestamp COMMENT '中转中心规划到达时间' ,
give_shifts_time                 timestamp COMMENT '中转中心最早散货支线时间' ,
tt_bill_cnt4) tt_bill_cnt                     string COMMENT '始发中转票数' ,
shipmentname                     string COMMENT '线路名称' ,
vehicletypename                  string COMMENT '车型' ,
bill_rate4) bill_rate                       decimal(16,4) COMMENT '占比' ,
case when string COMMENT '' )
comment 'insert overwrite table jms_dm.dm_enough_goods_detail_dt partition (dt)'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_enough_goods_detail_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
